Problem Note 31988: Dates in report mart SAS datasets have 0 instead of a correct date from live database
 |  |  |  |
In SAS® OpRisk Monitor, the reporting mart is created from the live data by running a SAS job to create a set of SAS datasets.
However, some dates in the created SAS datasets might have a value of 0 instead of an actual date.
You can resolve this problem by editing or adding a parameter setting for OPDATES in the file:
c:\Program Files\SAS\SAS 9.1\ormonitormva\sasstp\orm_job_autoexec.sas
Locate OPDATES by finding the comment "*** Please don't edit anything below this line.". The OPDATES parameter will be just before that line.
For PostgreSQL, set OPDATES = DT.
For Oracle, set OPDATES = DTTM.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS OpRisk Monitor | Microsoft Windows Server 2003 Standard Edition | 3.4.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.4.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.4.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Windows Vista | 3.4.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 3.4.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled AIX | 3.4.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| 64-bit Enabled Solaris | 3.4.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows NT Workstation | 3.4.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 3.4.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 3.4.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Datacenter Server | 3.4.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Advanced Server | 3.4.1 | 9.1 TS1M3 SP4 | ||||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-06-15 15:35:20 |
| Date Created: | 2008-05-05 09:22:07 |